Export to Excel Improvements for Matrix Visuals (GA)
The improvements to the Power BI matrix visual that ensures that structure of data exported to Excel is preserved is now Generally Available (GA).
The improvements to the Power BI matrix visual that ensures that structure of data exported to Excel is preserved is now Generally Available (GA).
We are announcing improvements to the Power BI audit logs that helps Power BI admins filter usage of Power BI data in Excel by workspace name and workspace id.
This feature allows users to export an Excel table from a Power BI report and keep that table connected to Power BI by refreshing it in the Excel grid.
The improvements to the Power BI experience in Excel include a new user-friendly UI that helps users easily search for datasets to build reports in the Excel grid. Also, users can now directly navigate from Excel to the Power BI service to discover new data artifacts in their organization or get additional insights from Power BI reports.
When users click Analyze in Excel in the Power BI service, the generated Excel workbook is automatically saved to OneDrive for Business and the workbook can be directly opened in a web browser using Excel for the web.